Backing up your iMIS database ensures that your data is secure; having a solid monthly routine in place minimizes the amount of data you could lose in a disaster.
Tip: Avoid using third-party backup SQL agents, which may cause problems when restoring your database.
Initial backup tasks
■ Schedule SQL Server Agent to back up your iMIS database nightly.
■ Configure the nightly backup to save the backup file (*.bak) to tape.
■ Set up SQL Server Agent to notify you if the backup fails.
Monthly backup tasks
■ Each month, test your backups: restore the file to a temporary database, open iMIS on it, and verify that it works.
■ After you verify the backup, pull a tape from the rotation and store it off-site, as a fail-safe.